formula help

[Guest]

I am trying to create a formula where it takes the result of one formula and
adds .60 if the answer to a question is yes but adds zero if it is no. The
first part of my formula is as follows:

=10+(IF(F44>1,(F44-1)*8.5))

It works fine. I just cannot get the second part to work with the first
part. Any help would be appreciated.

 

[Peo Sjoblom]

=IF(M44="yes",(10+(IF(F44>1,(F44-1)*8.5)))+0.6,10+(IF(F44>1,(F44-1)*8.5)))

replace M44 with the cell that holds the answers, you know I assume that if
the conditions in your formula isn't TRUE it will return 10?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Guest]

thank you so much! Works perfect now.

=IF(M44="yes",(10+(IF(F44>1,(F44-1)*8.5)))+0.6,10+(IF(F44>1,(F44-1)*8.5)))

replace M44 with the cell that holds the answers, you know I assume that if
the conditions in your formula isn't TRUE it will return 10?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon