Stringing If formulas

[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!

 

[Frank Kabel]

Hi
try
=IF(D42="NEW",221.75,IF(D42="USED",800,""))

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

 

[Amy]

-----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!