Related:
- Excel add cell value to text
- Excel add days to date - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Excel mod apk for pc - Download - Spreadsheets
- How to add at the rate in laptop - Guide
- How to add authorized user t mobile - Guide
1 response
ok, so this easy solution just needs two columns. In one column(b) you have cost...so some have 1.00 and some have free.
In the next column(c), you test for the actual value with the GREAT AND WONDERFUL =IF().
So the next column would contain =IF(b1="FREE",0.00,b1)
See if that works for ya! Very simple!
In the next column(c), you test for the actual value with the GREAT AND WONDERFUL =IF().
So the next column would contain =IF(b1="FREE",0.00,b1)
See if that works for ya! Very simple!