Re: attached spreadsheet
The problem I'm having is with the formula in cells H7 through H14. The formula works for all except H11.
I can't seem to figure out what I did wrong.
Please help, thank you.
Re: attached spreadsheet
The problem I'm having is with the formula in cells H7 through H14. The formula works for all except H11.
I can't seem to figure out what I did wrong.
Please help, thank you.
Last edited by lsbeuk; 02-22-2011 at 09:36 PM.
Hi,
Your value in D11 is 69.3, not 69; that's why the IF formula is returning $50. Change the format in D11 to see the decimal value.
Cheers,
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Got it! Thank you!!
Last edited by lsbeuk; 02-22-2011 at 09:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks