Thread: Trying to do a formula in Excel until the value is 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Trying to do a formula in Excel until the value is 0
Try inserting the additional IF check in front, viz:
=IF(E223=0,"Current",IF(D224=0,E223+B224,E223-D224))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
I am trying to do the following formula in Excel:

=IF(D224=0,E223+B224,E223-D224)

I want to do this until the value of Column E = 0, if it does I want
it to display "Current"


Reply With QuoteReply With Quote