0

Good morning,

If there is no value in B3 then the following calculation is needed, otherwise, the value in B3 should be used.

=IFS(B1>1000,(B1-1000)*0.06+200,B1<1001,B1*0.06)

But I can't seem to add B3="" to the beginning of the code without breaking it - please can someone let me know what I'm doing wrong?

Many thanks,

Nene
  • 55
  • 1
  • 7

1 Answers1

1

Use a IF() function then nest IFS() in it like-

=IF(B3="",IFS(B1>1000,(B1-1000)*0.06+200,B1<1001,B1*0.06),B3)
Harun24hr
  • 30,391
  • 4
  • 21
  • 36