Hello,
I need help with "if" function. I have two sheets. In the second sheet I wanna take data from first sheet with the following condition:
- if the value from the first sheet cell is greater than 8 than to return the number 8;
- if the value from the first sheet cell is equal or less then 8 thanto return 8-2;
- if the value from the first sheet cell is a text then to return the text.
I tried to use the function:
=IF(ssb!E5>8;8, if(ssb!e5>=8;ssb!e5-2), if(istext(ssb!e5);ssb!e5))
but it returns an error.
Any help will be appreciated.
Manny tnx.
Bookmarks