View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Nested IF function (simple)

Hi,

Am Fri, 29 Jun 2018 07:01:15 +0100 schrieb TeKouma:

Can anyone tell me why I am getting errors?
https://i.imgur.com/vRhe5Vz.png


try:
=E2+IF(L2=12.72,35,IF(L2=17.74,50,0))


Regards
Claus B.
--
Windows10
Office 2016