IF formulae problems

[jim-jams3]

hi

i have a IF formulae =IF(K25="Monthly",$B$33,B$34) but what i want is that if there is no value in cell k25 then the result will turn up as ""

 

[Domski]

What value wouuld K25 hold if the formula was to return the value from B34?

Dom

 

[Domski]

Try:

=IF(K25="","",IF(K25="Monthly",$B$33,B$34))

Dom

 

[VoG]

Try

=IF(K25="","", IF(K25="Monthly",$B$33,B$34))

 

[Yard]

=IF(K25="","",IF(K25="Monthly",$B$33,B$34))

 

[jim-jams3]

What value wouuld K25 hold if the formula was to return the value from B34?

Dom

the value if fase would be 550

 

[jim-jams3]

how does this work

 

[VoG]

how does this work

Take a look here http://spreadsheets.about.com/od/tipsandfaqs/qt/nested_if.htm

 

[Domski]

It tests if K25 is blank, if so returns "" (or nothing) and then moves onto to what to do if K25 isn't blank which is another IF statement. This then works as your original formula checking if K25 equals Monthly and returning B33 if so and B34 if not.

Dom