Stringing If formulas

  • Thread starter Thread starter aMY
  • Start date Start date
A

aMY

I need to use 2 different if formulas but can't figure
out how to put them together. Keeps coming back with the
value error.

Here is what I have
=IF(D42="NEW",221.75," "),IF(D42="USED",800," ")

Any help would be great!

Thanks in advance!
 
Hi
try
=IF(D42="NEW",221.75,IF(D42="USED",800,""))

Note: always better to return "" instead of " "
 
-----Original Message-----
Hi
try
=IF(D42="NEW",221.75,IF(D42="USED",800,""))

Note: always better to return "" instead of " "

--
Regards
Frank Kabel
Frankfurt, Germany



.
It worked thank you so much!
Click to expand...
 
Back
Top