I am trying to get this formular to work in H2
and i get errors no matter which way i put this in H2 and copy down
=IF(B2="1st",IF(B2="2Nd",IF(B2="3rd".1.0)))
any help to get this working will be appreciated
Regards
Graham
I am trying to get this formular to work in H2
and i get errors no matter which way i put this in H2 and copy down
=IF(B2="1st",IF(B2="2Nd",IF(B2="3rd".1.0)))
any help to get this working will be appreciated
Regards
Graham
What do you mean "not working"?
As written, that formula should return only FALSE.
Please describe, in words, what results you want depending on the entry in B2.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks for looking at this formula
in H2 I would like the result of the If formula to return value of G2 or Blank
I realize I did not put that in as to what i required
so I am saying In H2 if B2 -"1st" or B2 ="2nd" or b2 -"3rd" then return value in G2 or leave Blank
Regards
Graham
Try
=IF(OR(B2="1st",B2="2nd",B2="3rd"), G2, "")
What too u so Long
Thanks very much fot that, works a treat as u would know
Appreciate that Mikerickson
Regards Graham
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks