Thread: Excel formula Writing help
View Single Post
  #4 (permalink)  
Old 10-03-08, 08:10 PM
Adrian Kelland's Avatar
Adrian Kelland Adrian Kelland is offline
Newbie DO
  

Join Date: May 2003
Location: Exeter
Posts: 8,816
Adrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the waterAdrian Kelland is never out of the water
Quote:
Originally Posted by big_si
So let me get this straight... You want the value in H5 to perform a different calculation based on what the value in F5 is?

so... in cell H5 put

=IF(F5=0,F5,IF(F5=1,F5/1.175,IF(F5=2,F5/1.05,IF(F5=4,F5/407*7,"NOT VALID VALUE"))))

Should do the trick
gods, that makes me feel better
__________________
Interviewer; 'Think of a number between 1 and 10'
Me; 'e'
YD Fundraising 2007/8 - Amount Raised Royal National Lifeboat Institution UK Transplant Register Exeter BSAC
Reply With Quote